The Picasso Database Query Optimizer Visualizer

Plan Diagram A visualization of the estimated behavior of a selected plan in the plan diagram, when this specific plan is used throughout the selectivity space. Plan-replacement Diagrams Reduced Plan Diagram Shows the extent to which the original plan diagram may be simplified (by replacing some of the plans with their siblings in the plan diagram) without increasing the cost of any individual query by more than a user-specified threshold value. Robust Plan Diagram Shows the extent to which the plans in the original plan diagram may be replaced by comparatively robust plans without increasing the cost of any individual query by more than a user-specified threshold value. Run-time Diagrams Execution Cost Diagram A visualization of the runtime query response times over the selectivity space. Execution Cardinality Diagram A visualization of the runtime query result cardinalities over the selectivity space. Table 1: Picasso Diagram Suite